<?php
return array(
    'wms_purchaseorders'                      => array(
        'table'      => array(
            'id'          => 'id',
            'warehouseid' => 'warehouseid',
            'export_tax_rebate' => 'export_tax_rebate',
            'enterprise_dominant' => 'enterprise_dominant',
            'transfer_hopper_id' => 'transfer_hopper_id',
            'purchaseorder_date'    => 'purchaseorder_date',
            'supplier_id'       => 'supplier_id',
            'pay_way'     => 'pay_way',
            'purchase_id'       => 'purchase_id',
            'money'       => 'money',
            'transfer_type'  => 'transfer_type',
            'remark'      => 'remark',
            'check_man'   => 'check_man',
            'check_time'  => 'check_time',
            'transportation_expense'    => 'transportation_expense',
            'status'      => 'status',
            'store'   => 'store',
            'purchase_time'    => 'purchase_time',
            'createtype' => 'createtype',
            'pur_name'    => 'pur_name',
            'coin'        => 'coin',
            'ratetype'   => 'ratetype',
            'pass'        => 'pass'
        ),
        'tablename'  => array('wms_purchaseorders' => 'purchaseorders'),
        /*'storename'  => 'store',
        'storevalue' => array(
            106 => 4,
            107 => 5,
            54 => 6,
            38 => 7,
            94 => 8,
            41 => 9,
            21 => 13,
            55 => 14,
            69 => 15,
        ),*/
    ),
    'wms_purchaseorder_details'               => array(
        'table'     => array(
            'id'           => 'id',
            'warehouseid' => 'warehouseid',
            'purchaseorder_id'     => 'purchaseorder_id',
            'supplier'        => 'supplier',
            'sku'          => 'sku',
            'sku_name'     => 'sku_name',
            'storage_position'      => 'storage_position',
            'quantity'     => 'quantity',
            'single_price'        => 'single_price',
            'tax_rate'     => 'tax_rate',
            'money'        => 'money',
            'no_tax_money' => 'no_tax_money',
            'tax_money'    => 'tax_money',

            /*出口退税项目增加字段*/
            'real_tax_rate' => 'real_tax_rate',
            'export_tax' => 'export_tax',
            'export_money' => 'export_money',
            'unexport_tax' => 'unexport_tax',
            'unexport_money' => 'unexport_money',
            'tax_income' => 'tax_income',
            'income_rate' => 'income_rate',
            'item' => 'item',
            'hs_code' => 'hs_code',
            'invoice_amount' => 'invoice_amount',
            'remark'       => 'remark',
            'transportation_expense'     => 'transportation_expense',
            'arrive_date' => 'arrive_date',
            'recieve_quantity'      => 'recieve_quantity',
            'check_quantity'    => 'check_quantity',
            'return_quantity'   => 'return_quantity',
            'ware_quantity'     => 'ware_quantity',
            'status'       => 'status',
            'tax_way'      => 'tax_way',
            'details_date'     => 'details_date',
            'prime_cost'   => 'prime_cost',
            'reason'       => 'reason'
        ),
        'tablename' => array('wms_purchaseorder_details' => 'purchaseorder_details'),
    ),
    'wms_purchaseorder_details_sites'               => array(
        'table'     => array(
            'id' => 'id',
            'warehouseid' => 'warehouseid',
            'crontrigger' => 'crontrigger',
            'purchaseorders_id' => 'purchaseorders_id',
            'purchaseorder_details_id' => 'purchaseorder_details_id',
            'site_id' => 'site_id',
            'sku' => 'sku',
            'quantity' => 'quantity',
            'recieve_quantity' => 'recieve_quantity',
            'check_quantity' => 'check_quantity',
            'return_quantity' => 'return_quantity',
            'ware_quantity' => 'ware_quantity',
            'add_time' => 'add_time',
        ),
        'tablename' => array('wms_purchaseorder_details_sites' => 'purchaseorder_details_sites'),
        'storename'  => 'site_id',
        'storevalue' => array(
            106 => 4,
            107 => 5,
            54 => 6,
            38 => 7,
            94 => 8,
            41 => 9,
            21 => 13,
            55 => 14,
            69 => 15,
        ),
    ),
    'wms_recieve_invoices'      => array(
        'table'     => array(
            'id'               => 'id',
            'warehouseid' => 'warehouseid',
            'export_tax_rebate' => 'export_tax_rebate',
            'enterprise_dominant' => 'enterprise_dominant',
            'transfer_hopper_id' => 'transfer_hopper_id',
            'purchaseorder_id' => 'purchaseorder_id',
            'recieve_time'     => 'recieve_time',
            'recieve_man'      => 'recieve_man',
            'supplier'         => 'supplier',
            'transfer_type'        => 'transfer_type',
            'store'            => 'store'
        ),
        'tablename' => array('wms_recieve_invoices' => 'recieve_invoices'),
        /*'storename'  => 'store',
        'storevalue' => array(
            106 => 4,
            107 => 5,
            54 => 6,
            38 => 7,
            94 => 8,
            41 => 9,
            21 => 13,
            55 => 14,
            69 => 15,
        ),*/
    ),
    'wms_recieve_details'       => array(
        'table'     => array(
            'id'                 => 'id',
            'warehouseid' => 'warehouseid',
            'recieve_invoice_id' => 'recieve_invoice_id',
            'sku'                => 'sku',
            'sku_name'           => 'sku_name',
            'sku_standard'       => 'sku_standard',
            'storage_position'   => 'storage_position',
            'arrival_quantity'   => 'arrival_quantity',
            'purchase_quantity'  => 'purchase_quantity',
            'check_count'        => 'check_count'
        ),
        'tablename' => array('wms_recieve_details' => 'recieve_details'),
    ),
    'wms_check_quality_details' => array(
        'table'     => array(
            'id'                 => 'id',
            'warehouseid' => 'warehouseid',
            'export_tax_rebate' => 'export_tax_rebate',
            'enterprise_dominant' => 'enterprise_dominant',
            'transfer_hopper_id' => 'transfer_hopper_id',
            'invoice_date'       => 'invoice_date',
            'check_man'          => 'check_man',
            'purchaseorder_id'   => 'purchaseorder_id',
            'recieve_detail_id'  => 'recieve_detail_id',
            'supplier_id'        => 'supplier_id',
            'sku'                => 'sku',
            'sku_name'           => 'sku_name',
            'sku_standard'       => 'sku_standard',
            'storage_position'   => 'storage_position',
            'qualified_quantity' => 'qualified_quantity',
            'check_quantity'     => 'check_quantity',
            'unquality_count'    => 'unquality_count',
            'remark'             => 'remark',
            'print_status'       => 'print_status',
            'pur_evidence'       => 'pur_evidence',
            'fail_deal_way'      => 'fail_deal_way',
            'site_id'              => 'store',
            'transfer_type'   => 'transfer_type',
        ),
        'tablename' => array('wms_check_quality_details' => 'check_quality_details'),
        'storename'  => 'store',
        'storevalue' => array(
            106 => 4,
            107 => 5,
            54 => 6,
            38 => 7,
            94 => 8,
            41 => 9,
            21 => 13,
            55 => 14,
            69 => 15,
        ),
    ),
    /*'purchasesupplier'           => array(
        'table'     => array(
            'id'                => 'id',
            'poid'              => 'poid',
            'contact_id'        => 'contact_id',
            'supplier_id'       => 'supplier_id',
            'pay_way_id'        => 'pay_way_id',
            'payaccountinfo_id' => 'payaccountinfo_id',
            'createtime'        => 'createtime',
            'updatatime'        => 'updatatime',
            'oper_id'           => 'oper_id'
        ),
        'tablename' => array('purchasesupplier' => 'purchasesupplier'),
    ),*/

    'wms_unqualified_deal_invoices' => array(
        'table'     => array(
            'id' => 'id',
            'warehouseid' => 'warehouseid',
            'export_tax_rebate' => 'export_tax_rebate',
            'enterprise_dominant' => 'enterprise_dominant',
            'transfer_hopper_id' => 'transfer_hopper_id',
            'invoice_date' => 'invoice_date',
            'purchaseorder_id' => 'purchaseorder_id',
            'check_detail_id' => 'check_detail_id',
            'returned_parcel_id' => 'returned_parcel_id',
            'deliveryorders_id' => 'deliveryorders_id',
            'sku' => 'sku',
            'sku_name' => 'sku_name',
            'sku_standard' => 'sku_standard',
            'storage_position' => 'storage_position',
            'fail_deal_way' => 'fail_deal_way',
            'quantity' => 'quantity',
            'coupon_price' => 'coupon_price',
            'return_cost' => 'return_cost',
            'operate_man' => 'operate_man',
            'quality_man' => 'quality_man',
            'quality_remark' => 'quality_remark',
            'end_man' => 'end_man',
            'supplier' => 'supplier',
            'check_time' => 'check_time',
            'status' => 'status',
            'check_remark' => 'check_remark',
            'end_remark' => 'end_remark',
            'deal_time' => 'deal_time',
            'end_time' => 'end_time',
            'supplier_id' => 'supplier_id',
            'site_id' => 'store',
        ),
        'tablename' => array('wms_unqualified_deal_invoices' => 'unqualified_deal_invoices'),
        'storename'  => 'store',
        'storevalue' => array(
            106 => 4,
            107 => 5,
            54 => 6,
            38 => 7,
            94 => 8,
            41 => 9,
            21 => 13,
            55 => 14,
            69 => 15,
        ),
    ),

    'wms_deliveryorders' => array(
        'table'     => array(
            'id' => 'id',
            'warehouseid' => 'warehouseid',
            'delivery_date' => 'delivery_date',
            'op_time' => 'op_time',
            'order_id' => 'order_id',
            'orders_products_id' => 'orders_products_id',
            'orders_products_id' => 'purchaseorder_id',
            'delivery_department' => 'delivery_department',
            'delivery_man' => 'delivery_man',
            'supplier_id' => 'supplier_id',
            'sku' => 'sku',
            'sku_name' => 'sku_name',
            'sku_standard' => 'sku_standard',
            'storage_position' => 'storage_position',
            'quantity' => 'quantity',
            'single_price' => 'single_price',
            'money' => 'money',
            'cost' => 'cost',
            'internationalship_cost' => 'internationalship_cost',
            'remark' => 'remark',
            'type' => 'type',
        ),
        'tablename' => array('wms_deliveryorders' => 'deliveryorders'),
    ),

    'wms_bad_product_delivery' => array(
        'table'     => array(
            'id' => 'id',
            'warehouseid' => 'warehouseid',
            'export_tax_rebate' => 'export_tax_rebate',
            'enterprise_dominant' => 'enterprise_dominant',
            'transfer_hopper_id' => 'transfer_hopper_id',
            'sku' => 'sku',
            'sku_name' => 'sku_name',
            'sku_standard' => 'sku_standard',
            'storage_position' => 'storage_position',
            'quantity' => 'quantity',
            'supplier' => 'supplier',
            'coupon_price' => 'coupon_price',
            'return_cost' => 'return_cost',
            'status' => 'status',
            'unqualified_id' => 'unqualified_id',
            'operate_man' => 'operate_man',
            'purchase_man' => 'purchase_man',
            'unqualified_reason' => 'unqualified_reason',
            'check_detail_id' => 'check_detail_id',
            'fail_deal_way' => 'fail_deal_way',
            'deal_time' => 'deal_time',
            'warehouse_man' => 'warehouse_man',
            'out_time' => 'out_time',
            'warehouse_remark' => 'warehouse_remark',
            'site_id' => 'store',
            'purchaseorder_id' => 'purchaseorder_id',
            'pur_evidence' => 'pur_evidence',
            'print_status' => 'print_status',
        ),
        'tablename' => array('wms_bad_product_delivery' => 'bad_product_delivery'),
        'storename'  => 'store',
        'storevalue' => array(
            106 => 4,
            107 => 5,
            54 => 6,
            38 => 7,
            94 => 8,
            41 => 9,
            21 => 13,
            55 => 14,
            69 => 15,
        ),
    ),

    'wms_warehouseorders'        => array(
        'table'     => array(
            'id'             => 'id',
            'warehouseid'       => 'warehouseid',
            'sku'                => 'sku',
            'sku_name'           => 'sku_name',
            'warehouse_quantity'          => 'warehouse_quantity',
            'single_price'        => 'single_price',
            'money'              => 'money',
            'transportation_expense'           => 'transportation_expense',
            'cost'               => 'cost',
            'remark'             => 'remark',
            'export_tax_rebate' => 'export_tax_rebate',
            'enterprise_dominant' => 'enterprise_dominant',
            'transfer_hopper_id' => 'transfer_hopper_id',
            'purchaseorders_id' => 'purchaseorders_id',
            'op_time'         => 'op_time',
            'warehouse_date'          => 'warehouse_date',
            'type'     => 'type',
            'site_id'            => 'store',
            'warehouse_man'       => 'warehouse_man',
            'supplier_id'       => 'supplier_id',
            'transfer_type'  => 'transfer_type',
        ),
        'tablename' => array('wms_warehouseorders' => 'warehouseorders'),
        'storename'  => 'store',
        'storevalue' => array(
            106 => 4,
            107 => 5,
            54 => 6,
            38 => 7,
            94 => 8,
            41 => 9,
            21 => 13,
            55 => 14,
            69 => 15,
        ),
        /*'typename' => 'type',
        'typevalue' => array(
            10=>10,//正常入库
            20=>100,//调拨入库
            30=>30,//盘点入库
            40=>70,//其他入库
        ),*/
    ),

    /*出库单由于汇总系统没有仓库、主体字段；转运系统没有金额成本SKU中文名称字段，与财务还需要沟通业务，暂不同步*/
    /*'twms_stockout_detail'        => array(
        'table'     => array(
            'd.rec_id'             => 'id',
            'd.sku'                => 'sku',
            //'d.sku_name'           => 'sku_name',
            'd.goods_qty'          => 'warehouse_quantity',
            'd.goods_price'        => 'single_price',
            //'d.money'              => 'money',
            //'d.trans_fee'           => 'transportation_expense',
            //'d.cost'               => 'cost',
            'd.remark'             => 'remark',
            'sout.enterprise_dominant' => 'enterprise_dominant',
            'sout.transfer_hopper_id' => 'transfer_hopper_id',
            'sout.add_time'         => 'op_time',
            'sout.out_time'          => 'delivery_date',
            'sout.stockout_type'     => 'type',
            'sout.store'            => 'store',
            'sout.add_user'       => 'delivery_man',
            'sout.supplier'       => 'supplier_id',
            'sout.transport_mode'  => 'transfer_type',
        ),
        'tablename' => array('twms_stockout_detail' => 'deliveryorders'),
        'storename'  => 'store',
        'storevalue' => array(
            1  => 3,
            2  => 2,
            3  => 10,
            11 => 5,
            12 => 4,
            13 => 9,
            14 => 6,
            15 => 7,
            16 => 8
        ),
        'typename' => 'type',
        'typevalue' => array(
            10=>10,//正常出库
            100=>20,//调拨出库
            20=>30,//盘点出库
            70=>40,//其他出库
        ),
    )*/

);